const db = require('../../../config/SequelizeBase');

const Goods = db.defineModel('goods_detail',{
	goodsId:{
		type:db.STRING(64),
		allowNull:false,
    "field":"goods_id"
	},
	specName:{
		type:db.STRING(500),
		allowNull:false ,
    "field":"spec_name"
	},
	stockNum:{
		type:db.INTEGER,
		defaultValue: 0,
		allowNull:false ,
    "field":"stock_num"
	},
	unitPrice:{
		type:db.FLOAT,
		allowNull:false,
    "field":"unit_price"
	}
},{
	timestamps:false,
});

module.exports = Goods;